# -*- coding:utf-8 -*-

from sqlalchemy import Column, ForeignKey, String, DateTime, BigInteger, Integer
from config.database import BaseMixin, Base


class SysPost(Base, BaseMixin):
    __tablename__ = "sys_post"

    post_code = Column(String(64), nullable=False, comment='岗位编码')

    post_id = Column(BigInteger, primary_key=True, autoincrement=True, comment='岗位ID')

    post_name = Column(String(50), nullable=False, comment='岗位名称')

    post_sort = Column(Integer, nullable=False, comment='显示顺序')

    remark = Column(String(500), comment='备注')

    status = Column(String(1), nullable=False, comment='状态（0正常 1停用）')

    update_by = Column(String(64), comment='更新者')

